﻿CREATE TABLE [dbo].[DimGeneralMessageInformation]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[MessageType] [nvarchar] (50) NULL,
[MessageDirection] [nvarchar] (50) NULL,
[OrchestrationName] [nvarchar] (50) NULL,
[MessageSource] [nvarchar] (100) NULL,
[MessageDestination] [nvarchar] (100) NULL,
[NumberOfChildMessages] [float] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[MessageStartTime] [nvarchar] (50) NULL,
[MessageCommunicationMethod] [nvarchar] (100) NULL,
[MessageTransmissionSuccessful] [nvarchar] (50) NULL,
[MessageEndTime] [nvarchar] (50) NULL,
[SecDuration] [int] NULL,
[MSDuration] [int] NULL,
[GenMsginfoID_Key] [int] NOT NULL IDENTITY(1, 1),
[TransactionStatus] [nvarchar] (100) NULL,
[CurrentProcessingStep] [nvarchar] (100) NULL,
[NextProcessingStep] [nvarchar] (100) NULL,
[Receive_UTC] [datetime] NULL,
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[TransactionEndDate] [datetime] NULL,
[LastStatusUpdate] [datetime] NULL,
[TransactionStatusDescription] [nvarchar] (100) NULL,
[InsertDate] [datetime] NULL
) ON [PRIMARY]


